package com.besidewallpaper.wallpaper.dao;

import com.besidewallpaper.wallpaper.entity.WallpaperEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 
 * 
 * @author sotsukisaki
 * @email 3156263699@qq.com
 * @date 2024-09-26 15:00:30
 */
@Mapper
public interface WallpaperDao extends BaseMapper<WallpaperEntity> {

    @Select("SELECT pic_url FROM wallpaper WHERE id = #{id}")
    String getByIdWithURL(Long id);


    List<WallpaperEntity> selectAll();

    List<WallpaperEntity> selectAllByDesc();

    List<WallpaperEntity> queryPicTypeList(String picType);
}
